set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区
INSERT overwrite TABLE jms_dim.dim_center_indicator_config_base_dt PARTITION(dt)
select
modify_by
,modify_time
,status
,cgzy_worst
,cgzy_target
,cgzy_challenge
,cgzy_weights
,jgzy_worst
,jgzy_target
,jgzy_challenge
,jgzy_weights
,ksl_worst
,ksl_target
,ksl_challenge
,ksl_weights
,ysl_worst
,ysl_target
,ysl_challenge
,ysl_weights
,psl_worst
,psl_target
,psl_challenge
,psl_weights
,zfgx_worst
,zfgx_target
,zfgx_challenge
,zfgx_weights
,czxn_weights
,dprl_weights
,zcbgf_weights
,cjfl_number
,cjfl_whole_network
,cjfl_caps
,id
,czxn_target
,dt
from jms_ods.center_indicator_config
where dt='{{ execution_date | cst_ds }}'
 distribute by 1 ;